package com.jkoss.dao.jy;

import com.jkoss.pojo.jy.JiuyeGS;
import com.jkoss.pojo.jy.JiuyeGSExample;
import com.jkoss.tool.Page;

import java.util.List;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.ResultMap;
import org.apache.ibatis.annotations.Select;
import org.springframework.web.bind.annotation.RequestMapping;

public interface JiuyeGSMapper {
	
	@Select("select * from t_jiuyecomps")
	@ResultMap("com.jkoss.dao.jy.JiuyeGSMapper.BaseResultMap")
	List<JiuyeGS> listGs(Page<JiuyeGS> page);
	
	@Select("select a.*,b.ename from t_jiuyecomps a,t_emps b where a.eid=b.eid and a.jyid=${jyid}")
	@ResultMap("com.jkoss.dao.jy.JiuyeGSMapper.BaseResultMap2")
	JiuyeGS findByJyid(@Param("jyid") Integer jyid);
	
	@Select("select * from t_jiuyecomps")
	@ResultMap("com.jkoss.dao.jy.JiuyeGSMapper.BaseResultMap")
	List<JiuyeGS> findAll();
   
	int countByExample(JiuyeGSExample example);

    int deleteByExample(JiuyeGSExample example);

    int deleteByPrimaryKey(Integer jyid);

    int insert(JiuyeGS record);

    int insertSelective(JiuyeGS record);

    List<JiuyeGS> selectByExample(JiuyeGSExample example);

    JiuyeGS selectByPrimaryKey(Integer jyid);

    int updateByExampleSelective(@Param("record") JiuyeGS record, @Param("example") JiuyeGSExample example);

    int updateByExample(@Param("record") JiuyeGS record, @Param("example") JiuyeGSExample example);

    int updateByPrimaryKeySelective(JiuyeGS record);

    int updateByPrimaryKey(JiuyeGS record);

	


	

	
}